EVE Search - Tranquility Issues Resolved

All Channels

EVE General Discussion

Tranquility Issues Resolved

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Author	Thread Statistics \| Show CCP posts - 23 post(s)

CCP Wrangler	Posted - 2007.09.15 19:49:00 - [1] This Monday it was brought to our attention that an alliance couldn't get Sovereignty 4 in their capital system even though they should. Looking into it we concluded that their capital station was a conquerable station which shouldn't be possible to set as a capital station. Fixing this required changing procedures in the database so attempting to set a conquerable station as capital station causes an error. Unfortunately, due to unforeseen behavior in the server code a certain argument was passed to the procedure, which did not have anticipated default value, causing the procedure to error on every call from conquerable stations that were set as capital stations, of which there are 10 of on Tranquility. While hotfixing this we failed to notice that the error flag code we copied was bad, that error condition can possibly have caused other crashes, in the sense that it did not close the transaction. This in turn led to that every call to this procedure would lock up a session to the database as it waited indefinitely for the transaction to be either rolled back or closed. The sessions locking up created a plethora of different locks all over the database, causing us to chase for a ghost of the problem. Eventually this led to a database fail-over which meant Tranquility crashed. This oversight has been located in two other procedures as well, but none of them are called often enough on Tranquility to cause any real problems. To sum it up, a series of unfortunate exceptional cases set up an environment on TQ wherein 10 stations on the entire server could repeatedly lock sessions in the DB until it had to do a failover to free them up. As a result of this, our hotfixing protocols are being revised to prevent this from happening again in the future. Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


CCP Wrangler	Posted - 2007.09.15 20:11:00 - [2] Originally by: Pirate Tom Originally by: "CCP Wranglermuffin" ...wherein 10 stations on the entire server could repeatedly lock sessions in the DB until it had to do a failover to free them up... So in a roundabout sort of way, it really was BoB and Goonfleet (et al) causing the crash! No, they were not involved. I'd also like to clarify that this problem was not caused by any Alliance, we messed up and not any player(s). Originally by: torswin http://www.yonkis.com/mediaflash/1000000.swf thankyou! (same as wrangler (i think) posted but without the fleshlight ad). You people will never let me forget that, will you? Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


CCP Wrangler	Posted - 2007.09.15 20:19:00 - [3] Originally by: Pirate Tom Wrangler I was going for the obvious poke at the 'OMG BOB' and 'OMG GOONS' crowd. I know it was a code error. You explained that pretty clearly. I figured, I just wanted to make sure people understood that it was no Alliances fault that this happened. Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


CCP Wrangler	Posted - 2007.09.15 21:08:00 - [4] Originally by: ViolenTUK Edited by: ViolenTUK on 15/09/2007 20:47:59 In this crash the entire "3asy company" Alliance was lost of the database. All of the alliance members were kicked from the alliance and 3asy company doesnt show in the rankings list. Please CCP give us back our alliance. I'm sorry to hear that, can your CEO create a petition on it, or someone else within that alliance? I'll send off some emails too so we can get it handled. Originally by: Pistonbroke Edited by: Pistonbroke on 15/09/2007 20:55:15 Clarification please.... does this mean that conquerables can not ever be set as capital station? I believe that was never the intention. Originally by: Kalissa Does this mean if you've set a conquerable station to be a capital already but it's not kicked in yet (you've not done the 30 days) that it wont kick in when the 30 days are up? That is something I'll have to check into. Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


CCP Wrangler	Posted - 2007.09.16 13:27:00 - [5] When it comes to reimbursing ship losses and similar during this period of crashes that's not something we can comment on in this thread. As with all reimbursement it will be handled by our Customer Support people on a case by case basis. As has been said, it was never the intention that conquerable stations should be able to be set at capital stations. In the cases where that has been done we ask the alliances affected to work with out Customer Support team to resolve this issue. The 3asy company alliance appears not to have paid its bill, the crash revealed that and the alliance was disbanded. You will have to recreate the alliance to fix this, however we will help you out of you have any problems recreating the alliance and in case you had a alliance logo made we will make sure you get it back as soon as we can. That will be handled through the petition you made though. I hope this has answered the recent questions in this thread. Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


CCP Wrangler	Posted - 2007.09.16 14:01:00 - [6] Originally by: Guvnor RBM Edited by: Guvnor RBM on 16/09/2007 13:49:30 Thanks for that, I checked but we didn't get the bill... The cheque is in the post ect ect :) Any way, as long as it can be sorted If some one could contact me in game or 101 commander to get it running again it would great Thanks The bill is sent to the CEO of the Executor Corporation for the Alliance. Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


CCP Wrangler	Posted - 2007.09.16 14:42:00 - [7] Originally by: Marcus DeMon The biggest issue we have is not the ISK as such... BUT THERE IS NO BILL ! for us to pay :( The bill wasn't paid, and because of that the alliance disbanded. However, Guvnor RBM has a petition in and this will be dealt with there. Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


CCP Wrangler	Posted - 2007.09.16 14:46:00 - [8] "Powered by Stella Artois"?? Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ


CCP Wrangler	Posted - 2007.09.16 18:14:00 - [9] Originally by: Guvnor RBM The sig maker has disaperred, but yeah, I didnt notice my self for almost 6 weeks Probably due to Stella... Wrangler Community Manager EVE Online Contact Support - Contact Moderators - Report Bug - Submit News Leads - Knowledge Base Player Guide - Policies - Join ISD - Fan Submissions - DevFinder LiteÖ

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.